package com.sky.mapper;


import com.sky.entity.User;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;

import java.util.Map;

@Mapper
public interface UserMapper {
@Select("select * from user where openid = #{openid}")
    User getByopenid(String openid);

@Insert("insert into user(openid, name, phone, sex, id_number, avatar, create_time) " +
        "VALUES (#{openid},#{name},#{phone},#{sex},#{idNumber},#{avatar},#{createTime})")
@Options(useGeneratedKeys = true,keyProperty = "id")
void inst(User user);
/*
* 统计用户数据
* */
    Integer userBymap(Map map);
}
